﻿CREATE TABLE [Classifieds].[Postings]
(
	PostingID int NOT NULL IDENTITY(78600000,1), 
	CategoryID int NOT NULL,
	MemberID int NOT NULL,
	StatusID tinyint NOT NULL,
	Title varchar(70) NOT NULL,
	Price varchar(10) NULL,
	Location varchar(40) NULL,
	ReplyTo varchar(255) NOT NULL,
	[Description] text NOT NULL,
	CreatedOn smalldatetime NOT NULL,
	ExpiresOn smalldatetime NOT NULL
)
